package cn.tedu.egmybatis1.mapper;

import cn.tedu.egmybatis1.pojo.entity.Product;
import org.apache.ibatis.annotations.*;

import java.util.List;

/*
CREATE TABLE product(
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(30),
    price INT,
    stock INT
);
 */
@Mapper
public interface ProductMapper {
    @Insert("INSERT  INTO product(title,price,stock) VALUES (#{title},#{price},#{stock})")
    int insert(Product product);

   @Delete("DELETE  FROM  product WHERE id=#{id}")
    int deleteById(Integer id);

   @Update("UPDATE product " +
           "SET  title=#{title},price=#{price},stock=#{stock} " +
           "WHERE id=#{id}")
   int updateById(Product product);


   @Select("SELECT id,title,price,stock " +
           "FROM product " +
           "WHERE id=#{id}")
   Product selectById(Integer id);


    @Select("SELECT id,title,price,stock " +
            "FROM product " )
   List<Product> selectAll();









}

